SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlNomenclador
AS
SELECT     dbo.tb_CargosSalariales.idCargo AS ID, dbo.tb_CargosSalariales.cargo, dbo.tb_Escalafones.Descripcion, dbo.tb_CargosSalariales.Puntos
FROM         dbo.tb_CargosSalariales INNER JOIN
                      dbo.tb_Escalafones ON dbo.tb_CargosSalariales.Escalafon = dbo.tb_Escalafones.idEscalafon
GO
GRANT SELECT ON  [dbo].[vwlNomenclador] TO [Informatica]
GRANT SELECT ON  [dbo].[vwlNomenclador] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwlNomenclador] TO [SoloVer]
GRANT SELECT ON  [dbo].[vwlNomenclador] TO [Subsidios]
GRANT SELECT ON  [dbo].[vwlNomenclador] TO [SubsidiosConsulta]
GO
